Problem with VPN

------=_Part_123809_11258352.1156511182785
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,

We have here a system that uses Postgresql via odbc and it works well. The
problem is when we try to connect the database via odbc with VPN (virtual
privat network).

We are using Delphi and the message is: "Key violation".

Does anybody had the same experience with VPNs ?

Any suggestion is quite important to us.


ps: we are using Postgresql 8.1 and the proper msi odbc driver.

Regards ...

=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D -=3D-=3D-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D -=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

------=_Part_123809_11258352.1156511182785
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Re: Problem with VPN

Hi,

Actually We're working with Delphi 6.0 + openvpn + postgresql 8.1.1 with out
any problem.... It works very fine ... We're using a very old psqlODBC
version -07.03.0100- but It works ...

And Rigth now with a friend we're looking for a connection problem creating
CursorAdapters with VisualFoxpro+psqlODBC+Postgres 8.1.1 and if we try to
connect with the lastest version of the psqlODBC driver It generates the
following error

'unexpected protocol character during authentication; error while reading
from the socket'

BUT if we use the 07.03.0100 version of the psqlODBC IT WORKS FINE...

I hope this coulld be helpfull...

regards,

Alvaro Arcila

PD: Sorry for my poor english


>From: "Ezequias Rodrigues da Rocha"
>To: pgsql-odbc@postgresql.org
>Subject: [ODBC] Problem with VPN
>Date: Fri, 25 Aug 2006 10:06:22 -0300
>
>Hi list,
>
>We have here a system that uses Postgresql via odbc and it works well. The
>problem is when we try to connect the database via odbc with VPN (virtual
>privat network).
>
>We are using Delphi and the message is: "Key violation".
>
>Does anybody had the same experience with VPNs ?
>
>Any suggestion is quite important to us.
>
>
>ps: we are using Postgresql 8.1 and the proper msi odbc driver.
>
>Regards ...
>
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -=-=-=-=-=-=-
> Atenciosamente (Sincerely)
> Ezequias Rodrigues da Rocha
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -=-=-=-=-=-=-
>A pior das democracias ainda é melhor do que a melhor das ditaduras
>The worst of democracies is still better than the better of dictatorships
>http://ezequiasrocha.blogspot.com/



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Problem with VPN

ALVARO ARCILA wrote:
>=20
> Hi,
>=20
> Actually We're working with Delphi 6.0 + openvpn + postgresql 8.1.1 wit=
h=20
> out any problem.... It works very fine ... We're using a very old=20
> psqlODBC version -07.03.0100- but It works ...
>=20
> And Rigth now with a friend we're looking for a connection problem=20
> creating CursorAdapters with VisualFoxpro+psqlODBC+Postgres 8.1.1 and i=
f=20
> we try to connect with the lastest version of the psqlODBC driver It=20

Which version of driver are you using ?
If you are using 8.2.0002 please try the snapshot at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
..
You can simply replace the dll psqlodbc35w.dll without un/reregistration
if you installed 8.2.0002 version.

regards,
Hiroshi Inoue

> generates the following error
>=20
> 'unexpected protocol character during authentication; error while=20
> reading from the socket'
>=20
> BUT if we use the 07.03.0100 version of the psqlODBC IT WORKS FINE...
>=20
> I hope this coulld be helpfull...
>=20
> regards,
>=20
> Alvaro Arcila
>=20
> PD: Sorry for my poor english
>=20
>=20
>> From: "Ezequias Rodrigues da Rocha"
>> To: pgsql-odbc@postgresql.org
>> Subject: [ODBC] Problem with VPN
>> Date: Fri, 25 Aug 2006 10:06:22 -0300
>>
>> Hi list,
>>
>> We have here a system that uses Postgresql via odbc and it works well.=
=20
>> The
>> problem is when we try to connect the database via odbc with VPN (virt=
ual
>> privat network).
>>
>> We are using Delphi and the message is: "Key violation".
>>
>> Does anybody had the same experience with VPNs ?
>>
>> Any suggestion is quite important to us.
>>
>>
>> ps: we are using Postgresql 8.1 and the proper msi odbc driver.
>>
>> Regards ...
>>
>> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D -=3D-=3D-=3D-
>> Atenciosamente (Sincerely)
>> Ezequias Rodrigues da Rocha
>> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D -=3D-=3D-=3D-
>> A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
>> The worst of democracies is still better than the better of dictatorsh=
ips
>> http://ezequiasrocha.blogspot.com/
>=20
>=20
>=20
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>=20
>=20


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match